How to: Exclude records with a certain value using a filter.
Solution:
Open the table in the Table Datasheet view, select the value to use as the criteria, and use the 'Filter Excluding Selection' command.
1) If the Database window is not active, activate the Database window.
2) Open the table in the Table Datasheet view.
3) Do one of the following to select the value to use as criteria:
a) Select an entire cell entry.
Entire cell selected
b) Select only part of a cell entry.
c) Select a range of cells.
4) Right-click the mouse. (The shortcut menu appears.)
5) Select 'Filter Excluding Section' from the shortcut menu. (Records containing the selected value disappear from the datasheet.)
6) To view all entries in the table again, select the 'Records' menu and select 'Remove Filter/Sort'.
7) To reapply the previous existing filter, select the 'Records' menu and select 'Apply Filter/Sort'.
